Bank Marketing Strategy - Exploratory Data Analysis

Dataset statistics

Number of variables	18
Number of observations	8636
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.2 MiB
Average record size in memory	144.0 B

Variable types

Numeric	18

Alerts

`balance` is highly correlated with `balance_frequency` and 5 other fields	High correlation
`balance_frequency` is highly correlated with `balance` and 1 other fields	High correlation
`purchases` is highly correlated with `oneoff_purchases` and 5 other fields	High correlation
`oneoff_purchases` is highly correlated with `purchases` and 2 other fields	High correlation
`installments_purchases` is highly correlated with `purchases` and 3 other fields	High correlation
`cash_advance` is highly correlated with `balance` and 2 other fields	High correlation
`purchases_frequency` is highly correlated with `purchases` and 3 other fields	High correlation
`oneoff_purchases_frequency` is highly correlated with `purchases` and 2 other fields	High correlation
`purchases_installments_frequency` is highly correlated with `purchases` and 3 other fields	High correlation
`cash_advance_frequency` is highly correlated with `balance` and 2 other fields	High correlation
`cash_advance_trx` is highly correlated with `balance` and 2 other fields	High correlation
`purchases_trx` is highly correlated with `purchases` and 5 other fields	High correlation
`minimum_payments` is highly correlated with `balance` and 1 other fields	High correlation
`prc_full_payment` is highly correlated with `balance`	High correlation
`balance` is highly correlated with `credit_limit`	High correlation
`purchases` is highly correlated with `oneoff_purchases` and 3 other fields	High correlation
`oneoff_purchases` is highly correlated with `purchases` and 3 other fields	High correlation
`installments_purchases` is highly correlated with `purchases` and 2 other fields	High correlation
`cash_advance` is highly correlated with `cash_advance_frequency` and 1 other fields	High correlation
`purchases_frequency` is highly correlated with `oneoff_purchases_frequency` and 2 other fields	High correlation
`oneoff_purchases_frequency` is highly correlated with `oneoff_purchases` and 2 other fields	High correlation
`purchases_installments_frequency` is highly correlated with `installments_purchases` and 2 other fields	High correlation
`cash_advance_frequency` is highly correlated with `cash_advance` and 1 other fields	High correlation
`cash_advance_trx` is highly correlated with `cash_advance` and 1 other fields	High correlation
`purchases_trx` is highly correlated with `purchases` and 5 other fields	High correlation
`credit_limit` is highly correlated with `balance`	High correlation
`payments` is highly correlated with `purchases` and 1 other fields	High correlation
`balance` is highly correlated with `minimum_payments`	High correlation
`purchases` is highly correlated with `oneoff_purchases` and 4 other fields	High correlation
`oneoff_purchases` is highly correlated with `purchases` and 1 other fields	High correlation
`installments_purchases` is highly correlated with `purchases` and 3 other fields	High correlation
`cash_advance` is highly correlated with `cash_advance_frequency` and 1 other fields	High correlation
`purchases_frequency` is highly correlated with `purchases` and 3 other fields	High correlation
`oneoff_purchases_frequency` is highly correlated with `purchases` and 1 other fields	High correlation
`purchases_installments_frequency` is highly correlated with `installments_purchases` and 2 other fields	High correlation
`cash_advance_frequency` is highly correlated with `cash_advance` and 1 other fields	High correlation
`cash_advance_trx` is highly correlated with `cash_advance` and 1 other fields	High correlation
`purchases_trx` is highly correlated with `purchases` and 3 other fields	High correlation
`minimum_payments` is highly correlated with `balance`	High correlation
`balance` is highly correlated with `credit_limit`	High correlation
`purchases` is highly correlated with `oneoff_purchases` and 4 other fields	High correlation
`oneoff_purchases` is highly correlated with `purchases` and 2 other fields	High correlation
`installments_purchases` is highly correlated with `purchases` and 1 other fields	High correlation
`cash_advance` is highly correlated with `cash_advance_trx` and 1 other fields	High correlation
`purchases_frequency` is highly correlated with `oneoff_purchases_frequency` and 1 other fields	High correlation
`oneoff_purchases_frequency` is highly correlated with `purchases_frequency`	High correlation
`purchases_installments_frequency` is highly correlated with `purchases_frequency`	High correlation
`cash_advance_frequency` is highly correlated with `cash_advance_trx`	High correlation
`cash_advance_trx` is highly correlated with `cash_advance` and 1 other fields	High correlation
`purchases_trx` is highly correlated with `purchases` and 3 other fields	High correlation
`credit_limit` is highly correlated with `balance` and 2 other fields	High correlation
`payments` is highly correlated with `purchases` and 4 other fields	High correlation
`df_index` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`payments` has unique values	Unique
`purchases` has 1967 (22.8%) zeros	Zeros
`oneoff_purchases` has 4113 (47.6%) zeros	Zeros
`installments_purchases` has 3747 (43.4%) zeros	Zeros
`cash_advance` has 4431 (51.3%) zeros	Zeros
`purchases_frequency` has 1966 (22.8%) zeros	Zeros
`oneoff_purchases_frequency` has 4113 (47.6%) zeros	Zeros
`purchases_installments_frequency` has 3746 (43.4%) zeros	Zeros
`cash_advance_frequency` has 4431 (51.3%) zeros	Zeros
`cash_advance_trx` has 4431 (51.3%) zeros	Zeros
`purchases_trx` has 1967 (22.8%) zeros	Zeros
`prc_full_payment` has 5589 (64.7%) zeros	Zeros

Reproduction

Analysis started	2021-11-16 13:32:15.486262
Analysis finished	2021-11-16 13:33:50.138630
Duration	1 minute and 34.65 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

UNIFORM
UNIQUE

Distinct	8636
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4476.918828

Minimum	0
Maximum	8949
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0
5-th percentile	468.75
Q1	2266.75
median	4468.5
Q3	6697.25
95-th percentile	8489.25
Maximum	8949
Range	8949
Interquartile range (IQR)	4430.5

Descriptive statistics

Standard deviation	2565.759792
Coefficient of variation (CV)	0.5731084012
Kurtosis	-1.189516908
Mean	4476.918828
Median Absolute Deviation (MAD)	2215
Skewness	0.003298459329
Sum	38662671
Variance	6583123.311
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
5945	1	< 0.1%
5959	1	< 0.1%
5958	1	< 0.1%
5957	1	< 0.1%
5956	1	< 0.1%
5955	1	< 0.1%
5954	1	< 0.1%
5953	1	< 0.1%
5952	1	< 0.1%
Other values (8626)	8626	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
8949	1	< 0.1%
8948	1	< 0.1%
8947	1	< 0.1%
8945	1	< 0.1%
8943	1	< 0.1%
8942	1	< 0.1%
8941	1	< 0.1%
8940	1	< 0.1%
8939	1	< 0.1%
8938	1	< 0.1%

balance
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	8631
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1601.224893

Minimum	0
Maximum	19043.13856
Zeros	6
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0
5-th percentile	13.209472
Q1	148.095189
median	916.855459
Q3	2105.195853
95-th percentile	5936.635587
Maximum	19043.13856
Range	19043.13856
Interquartile range (IQR)	1957.100664

Descriptive statistics

Standard deviation	2095.5713
Coefficient of variation (CV)	1.308730154
Kurtosis	7.55387602
Mean	1601.224893
Median Absolute Deviation (MAD)	825.6064455
Skewness	2.374254167
Sum	13828178.17
Variance	4391419.074
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6	0.1%
40.900749	1	< 0.1%
1253.188317	1	< 0.1%
394.643543	1	< 0.1%
617.413726	1	< 0.1%
765.109593	1	< 0.1%
2583.247881	1	< 0.1%
1146.669364	1	< 0.1%
757.470201	1	< 0.1%
5058.299635	1	< 0.1%
Other values (8621)	8621	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6	0.1%
0.000199	1	< 0.1%
0.001146	1	< 0.1%
0.001214	1	< 0.1%
0.001289	1	< 0.1%
0.004816	1	< 0.1%
0.009684	1	< 0.1%
0.064811	1	< 0.1%
0.065402	1	< 0.1%
0.074724	1	< 0.1%

Value	Count	Frequency (%)
19043.13856	1	< 0.1%
18495.55855	1	< 0.1%
16304.88925	1	< 0.1%
16259.44857	1	< 0.1%
16115.5964	1	< 0.1%
15532.33972	1	< 0.1%
15258.2259	1	< 0.1%
15244.74865	1	< 0.1%
15155.53286	1	< 0.1%
14581.45914	1	< 0.1%

balance_frequency
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	42
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.8950351114

Minimum	0
Maximum	1
Zeros	6
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0.363636
Q1	0.909091
median	1
Q3	1
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.090909

Descriptive statistics

Standard deviation	0.2076968758
Coefficient of variation (CV)	0.2320544447
Kurtosis	3.369586149
Mean	0.8950351114
Median Absolute Deviation (MAD)	0
Skewness	-2.084161482
Sum	7729.523222
Variance	0.0431379922
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
1	6130	71.0%
0.909091	406	4.7%
0.818182	274	3.2%
0.727273	220	2.5%
0.545455	217	2.5%
0.636364	202	2.3%
0.454545	170	2.0%
0.363636	167	1.9%
0.272727	141	1.6%
0.181818	117	1.4%
Other values (32)	592	6.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6	0.1%
0.090909	25	0.3%
0.1	2	< 0.1%
0.125	2	< 0.1%
0.142857	1	< 0.1%
0.166667	1	< 0.1%
0.181818	117	1.4%
0.2	7	0.1%
0.222222	2	< 0.1%
0.25	5	0.1%

Value	Count	Frequency (%)
1	6130	71.0%
0.909091	406	4.7%
0.9	55	0.6%
0.888889	53	0.6%
0.875	57	0.7%
0.857143	50	0.6%
0.833333	59	0.7%
0.818182	274	3.2%
0.8	20	0.2%
0.777778	21	0.2%

purchases
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	6015
Distinct (%)	69.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1025.433874

Minimum	0
Maximum	49039.57
Zeros	1967
Zeros (%)	22.8%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	43.3675
median	375.405
Q3	1145.98
95-th percentile	4060.0925
Maximum	49039.57
Range	49039.57
Interquartile range (IQR)	1102.6125

Descriptive statistics

Standard deviation	2167.107984
Coefficient of variation (CV)	2.113357124
Kurtosis	108.677684
Mean	1025.433874
Median Absolute Deviation (MAD)	375.405
Skewness	8.055789007
Sum	8855646.94
Variance	4696357.014
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1967	22.8%
45.65	25	0.3%
150	15	0.2%
60	13	0.2%
200	12	0.1%
450	12	0.1%
100	12	0.1%
600	10	0.1%
70	10	0.1%
1000	9	0.1%
Other values (6005)	6551	75.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1967	22.8%
0.01	3	< 0.1%
0.05	1	< 0.1%
0.24	1	< 0.1%
1	2	< 0.1%
2	1	< 0.1%
4.44	1	< 0.1%
4.8	1	< 0.1%
4.99	1	< 0.1%
6.9	1	< 0.1%

Value	Count	Frequency (%)
49039.57	1	< 0.1%
41050.4	1	< 0.1%
40040.71	1	< 0.1%
38902.71	1	< 0.1%
35131.16	1	< 0.1%
32539.78	1	< 0.1%
31299.35	1	< 0.1%
27957.68	1	< 0.1%
27790.42	1	< 0.1%
26784.62	1	< 0.1%

oneoff_purchases
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	3922
Distinct (%)	45.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	604.9014382

Minimum	0
Maximum	40761.25
Zeros	4113
Zeros (%)	47.6%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	44.995
Q3	599.1
95-th percentile	2728.3725
Maximum	40761.25
Range	40761.25
Interquartile range (IQR)	599.1

Descriptive statistics

Standard deviation	1684.307803
Coefficient of variation (CV)	2.784433458
Kurtosis	160.1213079
Mean	604.9014382
Median Absolute Deviation (MAD)	44.995
Skewness	9.935775933
Sum	5223928.82
Variance	2836892.776
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4113	47.6%
45.65	43	0.5%
50	16	0.2%
200	15	0.2%
70	12	0.1%
150	12	0.1%
1000	12	0.1%
100	12	0.1%
250	11	0.1%
60	10	0.1%
Other values (3912)	4380	50.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4113	47.6%
0.01	6	0.1%
0.02	2	< 0.1%
0.05	1	< 0.1%
0.24	1	< 0.1%
1	4	< 0.1%
1.4	1	< 0.1%
2	1	< 0.1%
4.99	1	< 0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
40761.25	1	< 0.1%
40624.06	1	< 0.1%
34087.73	1	< 0.1%
33803.84	1	< 0.1%
26547.43	1	< 0.1%
26514.32	1	< 0.1%
25122.77	1	< 0.1%
24543.52	1	< 0.1%
23032.97	1	< 0.1%
22257.39	1	< 0.1%

installments_purchases
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	4341
Distinct (%)	50.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	420.8435329

Minimum	0
Maximum	22500
Zeros	3747
Zeros (%)	43.4%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	94.785
Q3	484.1475
95-th percentile	1800
Maximum	22500
Range	22500
Interquartile range (IQR)	484.1475

Descriptive statistics

Standard deviation	917.2451825
Coefficient of variation (CV)	2.179539688
Kurtosis	94.19337343
Mean	420.8435329
Median Absolute Deviation (MAD)	94.785
Skewness	7.216133309
Sum	3634404.75
Variance	841338.7248
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3747	43.4%
100	14	0.2%
200	13	0.2%
125	11	0.1%
150	11	0.1%
300	10	0.1%
75	9	0.1%
450	8	0.1%
500	8	0.1%
270	7	0.1%
Other values (4331)	4798	55.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3747	43.4%
1.95	1	< 0.1%
4.44	1	< 0.1%
4.8	1	< 0.1%
6.33	1	< 0.1%
7.26	1	< 0.1%
7.67	1	< 0.1%
9.58	1	< 0.1%
9.65	1	< 0.1%
9.68	1	< 0.1%

Value	Count	Frequency (%)
22500	1	< 0.1%
15497.19	1	< 0.1%
14686.1	1	< 0.1%
13184.43	1	< 0.1%
12738.47	1	< 0.1%
12560.85	1	< 0.1%
12541	1	< 0.1%
12375	1	< 0.1%
12235.05	1	< 0.1%
12128.94	1	< 0.1%

cash_advance
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	4206
Distinct (%)	48.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	994.175523

Minimum	0
Maximum	47137.21176
Zeros	4431
Zeros (%)	51.3%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1132.38549
95-th percentile	4721.415498
Maximum	47137.21176
Range	47137.21176
Interquartile range (IQR)	1132.38549

Descriptive statistics

Standard deviation	2121.458303
Coefficient of variation (CV)	2.133887079
Kurtosis	52.14352309
Mean	994.175523
Median Absolute Deviation (MAD)	0
Skewness	5.139628566
Sum	8585699.817
Variance	4500585.331
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4431	51.3%
2411.584248	1	< 0.1%
92.6579	1	< 0.1%
1486.243293	1	< 0.1%
855.232779	1	< 0.1%
3767.104707	1	< 0.1%
291.608512	1	< 0.1%
38.690552	1	< 0.1%
521.664369	1	< 0.1%
1974.202963	1	< 0.1%
Other values (4196)	4196	48.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4431	51.3%
14.222216	1	< 0.1%
18.042768	1	< 0.1%
18.117967	1	< 0.1%
18.123413	1	< 0.1%
18.126683	1	< 0.1%
18.149946	1	< 0.1%
18.204577	1	< 0.1%
18.240626	1	< 0.1%
18.280043	1	< 0.1%

Value	Count	Frequency (%)
47137.21176	1	< 0.1%
29282.10915	1	< 0.1%
27296.48576	1	< 0.1%
26268.69989	1	< 0.1%
26194.04954	1	< 0.1%
23130.82106	1	< 0.1%
22665.7785	1	< 0.1%
21943.84942	1	< 0.1%
20712.67008	1	< 0.1%
20277.33112	1	< 0.1%

purchases_frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.4960000002

Minimum	0
Maximum	1
Zeros	1966
Zeros (%)	22.8%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.083333
median	0.5
Q3	0.916667
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.833334

Descriptive statistics

Standard deviation	0.4012726404
Coefficient of variation (CV)	0.8090174198
Kurtosis	-1.638001348
Mean	0.4960000002
Median Absolute Deviation (MAD)	0.416667
Skewness	0.03304121629
Sum	4283.456002
Variance	0.161019732
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
1	2126	24.6%
0	1966	22.8%
0.083333	622	7.2%
0.916667	391	4.5%
0.5	390	4.5%
0.833333	367	4.2%
0.166667	367	4.2%
0.333333	350	4.1%
0.25	328	3.8%
0.583333	309	3.6%
Other values (37)	1420	16.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1966	22.8%
0.083333	622	7.2%
0.090909	41	0.5%
0.1	23	0.3%
0.111111	16	0.2%
0.125	25	0.3%
0.142857	22	0.3%
0.166667	367	4.2%
0.181818	15	0.2%
0.2	17	0.2%

Value	Count	Frequency (%)
1	2126	24.6%
0.916667	391	4.5%
0.909091	28	0.3%
0.9	23	0.3%
0.888889	18	0.2%
0.875	26	0.3%
0.857143	23	0.3%
0.833333	367	4.2%
0.818182	20	0.2%
0.8	9	0.1%

oneoff_purchases_frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2059087409

Minimum	0
Maximum	1
Zeros	4113
Zeros (%)	47.6%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.083333
Q3	0.333333
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.333333

Descriptive statistics

Standard deviation	0.3000536066
Coefficient of variation (CV)	1.457216461
Kurtosis	1.05820574
Mean	0.2059087409
Median Absolute Deviation (MAD)	0.083333
Skewness	1.504234233
Sum	1778.227886
Variance	0.09003216681
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	4113	47.6%
0.083333	1057	12.2%
0.166667	576	6.7%
1	469	5.4%
0.25	408	4.7%
0.333333	346	4.0%
0.416667	243	2.8%
0.5	232	2.7%
0.583333	197	2.3%
0.666667	167	1.9%
Other values (37)	828	9.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4113	47.6%
0.083333	1057	12.2%
0.090909	54	0.6%
0.1	36	0.4%
0.111111	24	0.3%
0.125	35	0.4%
0.142857	33	0.4%
0.166667	576	6.7%
0.181818	33	0.4%
0.2	26	0.3%

Value	Count	Frequency (%)
1	469	5.4%
0.916667	151	1.7%
0.909091	4	< 0.1%
0.9	1	< 0.1%
0.888889	2	< 0.1%
0.875	6	0.1%
0.857143	1	< 0.1%
0.833333	115	1.3%
0.818182	10	0.1%
0.8	4	< 0.1%

purchases_installments_frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.3688203456

Minimum	0
Maximum	1
Zeros	3746
Zeros (%)	43.4%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.166667
Q3	0.75
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.75

Descriptive statistics

Standard deviation	0.3980929442
Coefficient of variation (CV)	1.079368177
Kurtosis	-1.4192794
Mean	0.3688203456
Median Absolute Deviation (MAD)	0.166667
Skewness	0.4877529543
Sum	3185.132505
Variance	0.1584779922
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	3746	43.4%
1	1297	15.0%
0.416667	381	4.4%
0.916667	340	3.9%
0.833333	304	3.5%
0.5	303	3.5%
0.166667	296	3.4%
0.666667	290	3.4%
0.75	284	3.3%
0.083333	249	2.9%
Other values (37)	1146	13.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3746	43.4%
0.083333	249	2.9%
0.090909	10	0.1%
0.1	5	0.1%
0.111111	8	0.1%
0.125	4	< 0.1%
0.142857	5	0.1%
0.166667	296	3.4%
0.181818	14	0.2%
0.2	8	0.1%

Value	Count	Frequency (%)
1	1297	15.0%
0.916667	340	3.9%
0.909091	25	0.3%
0.9	18	0.2%
0.888889	28	0.3%
0.875	28	0.3%
0.857143	29	0.3%
0.833333	304	3.5%
0.818182	20	0.2%
0.8	17	0.2%

cash_advance_frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	54
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1376042043

Minimum	0
Maximum	1.5
Zeros	4431
Zeros (%)	51.3%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.25
95-th percentile	0.583333
Maximum	1.5
Range	1.5
Interquartile range (IQR)	0.25

Descriptive statistics

Standard deviation	0.2017914306
Coefficient of variation (CV)	1.466462683
Kurtosis	3.184233316
Mean	0.1376042043
Median Absolute Deviation (MAD)	0
Skewness	1.795915039
Sum	1188.349908
Variance	0.04071978147
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4431	51.3%
0.083333	980	11.3%
0.166667	730	8.5%
0.25	573	6.6%
0.333333	434	5.0%
0.416667	272	3.1%
0.5	209	2.4%
0.583333	142	1.6%
0.666667	124	1.4%
0.090909	66	0.8%
Other values (44)	675	7.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4431	51.3%
0.083333	980	11.3%
0.090909	66	0.8%
0.1	36	0.4%
0.111111	23	0.3%
0.125	43	0.5%
0.142857	43	0.5%
0.166667	730	8.5%
0.181818	41	0.5%
0.2	21	0.2%

Value	Count	Frequency (%)
1.5	1	< 0.1%
1.25	1	< 0.1%
1.166667	2	< 0.1%
1.142857	1	< 0.1%
1.125	1	< 0.1%
1.1	1	< 0.1%
1.090909	1	< 0.1%
1	24	0.3%
0.916667	27	0.3%
0.909091	3	< 0.1%

cash_advance_trx
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	65
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.313918481

Minimum	0
Maximum	123
Zeros	4431
Zeros (%)	51.3%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4
95-th percentile	15
Maximum	123
Range	123
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	6.912506117
Coefficient of variation (CV)	2.085901074
Kurtosis	60.42852324
Mean	3.313918481
Median Absolute Deviation (MAD)	0
Skewness	5.67332683
Sum	28619
Variance	47.78274082
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4431	51.3%
1	839	9.7%
2	602	7.0%
3	429	5.0%
4	374	4.3%
5	300	3.5%
6	241	2.8%
7	202	2.3%
8	169	2.0%
10	147	1.7%
Other values (55)	902	10.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4431	51.3%
1	839	9.7%
2	602	7.0%
3	429	5.0%
4	374	4.3%
5	300	3.5%
6	241	2.8%
7	202	2.3%
8	169	2.0%
9	108	1.3%

Value	Count	Frequency (%)
123	3	< 0.1%
110	1	< 0.1%
107	1	< 0.1%
93	1	< 0.1%
80	1	< 0.1%
71	1	< 0.1%
69	1	< 0.1%
63	1	< 0.1%
62	3	< 0.1%
61	1	< 0.1%

purchases_trx
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	173
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.03323298

Minimum	0
Maximum	358
Zeros	1967
Zeros (%)	22.8%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	7
Q3	18
95-th percentile	59
Maximum	358
Range	358
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	25.1804684
Coefficient of variation (CV)	1.674986906
Kurtosis	33.95227887
Mean	15.03323298
Median Absolute Deviation (MAD)	7
Skewness	4.578418451
Sum	129827
Variance	634.0559887
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1967	22.8%
1	606	7.0%
12	537	6.2%
2	345	4.0%
6	340	3.9%
3	294	3.4%
4	277	3.2%
7	265	3.1%
8	263	3.0%
5	254	2.9%
Other values (163)	3488	40.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1967	22.8%
1	606	7.0%
2	345	4.0%
3	294	3.4%
4	277	3.2%
5	254	2.9%
6	340	3.9%
7	265	3.1%
8	263	3.0%
9	240	2.8%

Value	Count	Frequency (%)
358	1	< 0.1%
347	1	< 0.1%
344	1	< 0.1%
309	1	< 0.1%
308	1	< 0.1%
298	1	< 0.1%
274	1	< 0.1%
273	1	< 0.1%
254	1	< 0.1%
248	2	< 0.1%

credit_limit
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	203
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4522.09103

Minimum	50
Maximum	30000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	50
5-th percentile	1000
Q1	1600
median	3000
Q3	6500
95-th percentile	12000
Maximum	30000
Range	29950
Interquartile range (IQR)	4900

Descriptive statistics

Standard deviation	3659.240379
Coefficient of variation (CV)	0.8091921094
Kurtosis	2.773473055
Mean	4522.09103
Median Absolute Deviation (MAD)	1800
Skewness	1.507019041
Sum	39052778.13
Variance	13390040.15
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3000	752	8.7%
1500	695	8.0%
1200	597	6.9%
1000	596	6.9%
2500	584	6.8%
4000	471	5.5%
6000	449	5.2%
5000	370	4.3%
2000	364	4.2%
7500	273	3.2%
Other values (193)	3485	40.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
50	1	< 0.1%
150	5	0.1%
200	3	< 0.1%
300	14	0.2%
400	3	< 0.1%
450	6	0.1%
500	112	1.3%
600	21	0.2%
650	1	< 0.1%
700	20	0.2%

Value	Count	Frequency (%)
30000	2	< 0.1%
28000	1	< 0.1%
25000	1	< 0.1%
23000	2	< 0.1%
22500	1	< 0.1%
22000	1	< 0.1%
21500	2	< 0.1%
21000	2	< 0.1%
20500	1	< 0.1%
20000	10	0.1%

payments
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	8636
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1784.478099

Minimum	0.049513
Maximum	50721.48336
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0.049513
5-th percentile	143.5595672
Q1	418.5592373
median	896.675701
Q3	1951.14209
95-th percentile	6152.318659
Maximum	50721.48336
Range	50721.43385
Interquartile range (IQR)	1532.582853

Descriptive statistics

Standard deviation	2909.81009
Coefficient of variation (CV)	1.630622473
Kurtosis	54.27081446
Mean	1784.478099
Median Absolute Deviation (MAD)	592.6225195
Skewness	5.873048587
Sum	15410752.86
Variance	8466994.762
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
201.802084	1	< 0.1%
6372.619037	1	< 0.1%
162.949236	1	< 0.1%
164.403739	1	< 0.1%
1679.00486	1	< 0.1%
209.392729	1	< 0.1%
1014.549633	1	< 0.1%
272.517748	1	< 0.1%
32.924384	1	< 0.1%
1899.738286	1	< 0.1%
Other values (8626)	8626	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.049513	1	< 0.1%
0.056466	1	< 0.1%
3.500505	1	< 0.1%
4.523555	1	< 0.1%
4.841543	1	< 0.1%
9.533313	1	< 0.1%
12.773144	1	< 0.1%
14.500688	1	< 0.1%
16.385421	1	< 0.1%
18.125527	1	< 0.1%

Value	Count	Frequency (%)
50721.48336	1	< 0.1%
46930.59824	1	< 0.1%
40627.59524	1	< 0.1%
39461.9658	1	< 0.1%
39048.59762	1	< 0.1%
36066.75068	1	< 0.1%
35843.62593	1	< 0.1%
34107.07499	1	< 0.1%
33994.72785	1	< 0.1%
33486.31044	1	< 0.1%

minimum_payments
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	8635
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	864.3049429

Minimum	0.019163
Maximum	76406.20752
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0.019163
5-th percentile	73.3585415
Q1	169.1635455
median	312.4522915
Q3	825.4964627
95-th percentile	2766.593894
Maximum	76406.20752
Range	76406.18836
Interquartile range (IQR)	656.3329173

Descriptive statistics

Standard deviation	2372.56635
Coefficient of variation (CV)	2.745057019
Kurtosis	283.9630416
Mean	864.3049429
Median Absolute Deviation (MAD)	190.372786
Skewness	13.62219309
Sum	7464137.487
Variance	5629071.086
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
299.351881	2	< 0.1%
342.28649	1	< 0.1%
184.464721	1	< 0.1%
276.486072	1	< 0.1%
309.140865	1	< 0.1%
354.281114	1	< 0.1%
216.090433	1	< 0.1%
277.546713	1	< 0.1%
150.317143	1	< 0.1%
1600.26917	1	< 0.1%
Other values (8625)	8625	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.019163	1	< 0.1%
0.037744	1	< 0.1%
0.05588	1	< 0.1%
0.059481	1	< 0.1%
0.117036	1	< 0.1%
0.261984	1	< 0.1%
0.311953	1	< 0.1%
0.319475	1	< 0.1%
1.113027	1	< 0.1%
1.334075	1	< 0.1%

Value	Count	Frequency (%)
76406.20752	1	< 0.1%
61031.6186	1	< 0.1%
56370.04117	1	< 0.1%
50260.75947	1	< 0.1%
43132.72823	1	< 0.1%
42629.55117	1	< 0.1%
38512.12477	1	< 0.1%
31871.36379	1	< 0.1%
30528.4324	1	< 0.1%
29019.80288	1	< 0.1%

prc_full_payment
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1593036248

Minimum	0
Maximum	1
Zeros	5589
Zeros (%)	64.7%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.166667
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.166667

Descriptive statistics

Standard deviation	0.2962709094
Coefficient of variation (CV)	1.859787621
Kurtosis	2.201598481
Mean	0.1593036248
Median Absolute Deviation (MAD)	0
Skewness	1.88602713
Sum	1375.746104
Variance	0.08777645176
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	5589	64.7%
1	488	5.7%
0.083333	426	4.9%
0.166667	166	1.9%
0.5	156	1.8%
0.25	156	1.8%
0.090909	153	1.8%
0.333333	134	1.6%
0.1	94	1.1%
0.2	83	1.0%
Other values (37)	1191	13.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5589	64.7%
0.083333	426	4.9%
0.090909	153	1.8%
0.1	94	1.1%
0.111111	61	0.7%
0.125	52	0.6%
0.142857	54	0.6%
0.166667	166	1.9%
0.181818	75	0.9%
0.2	83	1.0%

Value	Count	Frequency (%)
1	488	5.7%
0.916667	77	0.9%
0.909091	19	0.2%
0.9	16	0.2%
0.888889	12	0.1%
0.875	18	0.2%
0.857143	12	0.1%
0.833333	63	0.7%
0.818182	17	0.2%
0.8	33	0.4%

tenure
Real number (ℝ_≥0)

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.53439092

Minimum	6
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	67.6 KiB

Quantile statistics

Minimum	6
5-th percentile	8
Q1	12
median	12
Q3	12
95-th percentile	12
Maximum	12
Range	6
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.310983661
Coefficient of variation (CV)	0.1136586812
Kurtosis	8.15670142
Mean	11.53439092
Median Absolute Deviation (MAD)	0
Skewness	-3.011140523
Sum	99611
Variance	1.718678158
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
12	7346	85.1%
11	356	4.1%
10	226	2.6%
6	184	2.1%
8	183	2.1%
7	177	2.0%
9	164	1.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6	184	2.1%
7	177	2.0%
8	183	2.1%
9	164	1.9%
10	226	2.6%
11	356	4.1%
12	7346	85.1%

Value	Count	Frequency (%)
12	7346	85.1%
11	356	4.1%
10	226	2.6%
9	164	1.9%
8	183	2.1%
7	177	2.0%
6	184	2.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	balance	balance_frequency	purchases	oneoff_purchases	installments_purchases	cash_advance	purchases_frequency	oneoff_purchases_frequency	purchases_installments_frequency	cash_advance_frequency	cash_advance_trx	purchases_trx	credit_limit	payments	minimum_payments	prc_full_payment	tenure
0	0	40.900749	0.818182	95.40	0.00	95.40	0.000000	0.166667	0.000000	0.083333	0.00	0	2	1000.0	201.802084	139.509787	0.000000	12
1	1	3202.467416	0.909091	0.00	0.00	0.00	6442.945483	0.000000	0.000000	0.000000	0.25	4	0	7000.0	4103.032597	1072.340217	0.222222	12
2	2	2495.148862	1.000000	773.17	773.17	0.00	0.000000	1.000000	1.000000	0.000000	0.00	0	12	7500.0	622.066742	627.284787	0.000000	12
3	4	817.714335	1.000000	16.00	16.00	0.00	0.000000	0.083333	0.083333	0.000000	0.00	0	1	1200.0	678.334763	244.791237	0.000000	12
4	5	1809.828751	1.000000	1333.28	0.00	1333.28	0.000000	0.666667	0.000000	0.583333	0.00	0	8	1800.0	1400.057770	2407.246035	0.000000	12
5	6	627.260806	1.000000	7091.01	6402.63	688.38	0.000000	1.000000	1.000000	1.000000	0.00	0	64	13500.0	6354.314328	198.065894	1.000000	12
6	7	1823.652743	1.000000	436.20	0.00	436.20	0.000000	1.000000	0.000000	1.000000	0.00	0	12	2300.0	679.065082	532.033990	0.000000	12
7	8	1014.926473	1.000000	861.49	661.49	200.00	0.000000	0.333333	0.083333	0.250000	0.00	0	5	7000.0	688.278568	311.963409	0.000000	12
8	9	152.225975	0.545455	1281.60	1281.60	0.00	0.000000	0.166667	0.166667	0.000000	0.00	0	3	11000.0	1164.770591	100.302262	0.000000	12
9	10	1293.124939	1.000000	920.12	0.00	920.12	0.000000	1.000000	0.000000	1.000000	0.00	0	12	1200.0	1083.301007	2172.697765	0.000000	12

Last rows

	df_index	balance	balance_frequency	purchases	oneoff_purchases	installments_purchases	cash_advance	purchases_frequency	oneoff_purchases_frequency	purchases_installments_frequency	cash_advance_frequency	cash_advance_trx	purchases_trx	credit_limit	payments	minimum_payments	prc_full_payment	tenure
8626	8938	78.818407	0.500000	0.00	0.00	0.00	1113.186078	0.000000	0.000000	0.000000	0.166667	7	0	1200.0	1397.770131	21.821194	0.333333	6
8627	8939	728.352548	1.000000	734.40	734.40	0.00	239.891038	0.333333	0.333333	0.000000	0.166667	2	2	1000.0	72.530037	110.950798	0.000000	6
8628	8940	130.838554	1.000000	591.24	0.00	591.24	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	475.523262	82.771320	1.000000	6
8629	8941	5967.475270	0.833333	214.55	0.00	214.55	8555.409326	0.833333	0.000000	0.666667	0.666667	13	5	9000.0	966.202912	861.949906	0.000000	6
8630	8942	40.829749	1.000000	113.28	0.00	113.28	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	94.488828	86.283101	0.250000	6
8631	8943	5.871712	0.500000	20.90	20.90	0.00	0.000000	0.166667	0.166667	0.000000	0.000000	0	1	500.0	58.644883	43.473717	0.000000	6
8632	8945	28.493517	1.000000	291.12	0.00	291.12	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	325.594462	48.886365	0.500000	6
8633	8947	23.398673	0.833333	144.40	0.00	144.40	0.000000	0.833333	0.000000	0.666667	0.000000	0	5	1000.0	81.270775	82.418369	0.250000	6
8634	8948	13.457564	0.833333	0.00	0.00	0.00	36.558778	0.000000	0.000000	0.000000	0.166667	2	0	500.0	52.549959	55.755628	0.250000	6
8635	8949	372.708075	0.666667	1093.25	1093.25	0.00	127.040008	0.666667	0.666667	0.000000	0.333333	2	23	1200.0	63.165404	88.288956	0.000000	6

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows